MFG SAP Event Listener - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
| Module | Description |
|---|---|
| map-customer-and-contact-points-to-cim | SAP HANA Platform Event Business Partner message to CIM Mapping |
| map-orders-and-contact-points-to-cim | SAP HANA Platform Event Order message to CIM Mapping |
| map-organization-to-cim | SAP HANA Platform Event Business Partner message to CIM Mapping |
map-customer-and-contact-points-to-cim
SAP HANA Platform Event Business Partner message to CIM Mapping
Source:
./src/main/resources/dwl/map-customer-and-contact-points-to-cim.dwl
Functions
fun getFormattedDateTime (toFormat)
Formats the date-time to the type accepted by CIM
Mapping Tables
Maps event payload from SAP HANA Business Partner Event Listener to CIM Customer format.
| CIM - Customer | Event payload from SAP HANA Business Partner Event Listener | Description |
|---|---|---|
| id | businessPartner.Common.YY1_SME_MPARTYROLEID_M_bus | The Global ID of the customer in MDM system |
| partyRoleType | "Customer" | The party role type - Set as "Customer" |
| party[0].id | businessPartner.InternalID | The party identifier - Set as null |
| party[0].partyType | "Individual" | The party type - Set as Individual |
| party[0].personName | person.Name.GivenName person.Name.GivenName | The Person Name in SAP HANA |
| party[0].firstName | person.Name.GivenName | The firstname of the customer in SAP HANA |
| party[0].lastName | person.Name.FamilyName | The lastname of the customer in SAP HANA |
| party[0].contactPoints[0].contactPointType | "ContactPointAddress" | The contact point type - Set as "ContactPointAddress" |
| party[0].contactPoints[0].id | null | The contact point type identifier in SAP HANA - Set as null |
| party[0].contactPoints[0].activeFromDate | address.ValidityPeriod.StartDate | The date from which the contact point is active - Set as Start date |
| party[0].contactPoints[0].addressLine1 | address.Address.PostalAddress.StreetName | The Mailing street of the customer in SAP HANA |
| party[0].contactPoints[0].cityName | address.Address.PostalAddress.CityName | The Mailing City of the customer in SAP HANA |
| party[0].contactPoints[0].postalCodeText | address.Address.PostalAddress.StreetPostalCode | The postal code of the customer in SAP HANA |
| party[0].contactPoints[0].stateProvinceName | address.Address.PostalAddress.RegionCode | The state province of the customer in SAP HANA |
| party[0].contactPoints[0].countryName | address.Address.PostalAddress.CountryCode | The country of the customer in SAP HANA |
| primaryFlag | "true" | Set as true |
| isUsedForBilling | "false" | Set as false |
| contactPoints.geoLatitude | NA | Set as null |
| contactPoints.geoLongitude | NA | Set as null |
| contactPoints.geoAccuracy | NA | Set as null |
| party[0].contactPoints[1].contactPointType | "ContactPointEmail" | The contact point type - Set as "ContactPointEmail" |
| party[0].contactPoints[1].id | null | The contact point type identifier in SAP HANA - Set as null |
| party[0].contactPoints[1].activeFromDate | address.Address.Email.ValidityPeriod.StartDate | The date from which the contact point is active - Set as Start date |
| party[0].contactPoints[1].emailAddress | address.Address.Email.URI | The Email address of the customer in SAP HANA |
| primaryFlag | "true" | Set as true |
| party[0].contactPoints[2].contactPointType | "ContactPointPhone" | The contact point type - Set as "ContactPointPhone" |
| party[0].contactPoints[2].id | null | The contact point type identifier in SAP HANA - Set as null |
| party[0].contactPoints[2].activeFromDate | address.Address.Telephone.ValidityPeriod.StartDate | The date from which the contact point is active - Set as Start date |
| party[0].contactPoints[2].telephoneNumber | address.Address.Telephone.Number.SubscriberID | The telephone number of the customer in SAP HANA |
| primaryFlag | "true" | Set as true |
| isSMSCapable | "false" | Set as false |
| externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| externalIds[0].externalId | Id | The identifier of the customer in SAP HANA |
| externalIds[0].externalIdType | "SAP_4HANA" | The external identifier type - Set as "SAP_4HANA" |
| externalIds[0].status | "VALID" | The status of the ExternalId - Set as "VALID" |
| customerNumber | businessPartner.InternalID | The customer number stored in SAP HANA - default as "" |
| customerStatus | "ACTIVE" | The customer Status in SAP HANA - Set as Active |
| auditInfo.createdDate | now() | Timestamp of when the customer was created |
| auditInfo.createdBy | CreatedById | Identifies the system or user which created the customer |
| auditInfo.updatedDate | now() | Timestamp of when the customer was last updated |
| auditInfoupdatedBy | LastModifiedById__c | Identifies the system or user which last updated the customer |
| auditInfo.isDeleted | IsDeleted | Indicates whether or not the customer has been soft-deleted |
| salesOrganization | customer.SalesArrangement.SalesOrganisationID | The Organization Id in SAP HANA |
| distributionChannel | customer.SalesArrangement.DistributionChannelCode | The DistributionChannelCode Id in SAP HANA |
| division | customer.SalesArrangement.DivisionCode | The DivisionCode Id in SAP HANA |
| customerPricingProcedure | customer.SalesArrangement.PricingProcedureDeterminationCodeLong | The PricingProcedureDeterminationCodeLong Id in SAP HANA |
| customerRole | businessPartner.Role.RoleCode | The RoleCode Id in SAP HANA |
| primaryAccount | YY1_SME_ParentID_MFG | The Primary Account ID |
map-orders-and-contact-points-to-cim
SAP HANA Platform Event Order message to CIM Mapping
Source:
./src/main/resources/dwl/map-orders-and-contact-points-to-cim.dwl
Mapping Tables
Search Orders and Contact cim mapping.
| CIM Target Field | SAP source field | Description of source field | |
|---|---|---|---|
| name | NA | set to "" | |
| requestedStartDate | payload.SalesOrderBulkReplication.SalesOrder.SalesOrderDate | "" | |
| id | payload.SalesOrderBulkReplication.SalesOrder.YY1_SME_MORDERID_MFG_SDH | "" | |
| orderNumber | payload.SalesOrderBulkReplication.SalesOrder.SalesOrderID | "" | |
| description | NA | set to "" | |
| orderCurrency | payload.SalesOrderBulkReplication.SalesOrder.TransactionCurrency | "" | |
| grandTotalAmount | payload.SalesOrderBulkReplication.SalesOrder.TotalNetAmount | "" | |
| salesOrderStatus payload.SalesOrderBulkReplication.SalesOrder.OverallDeliveryStatus | If value's "C" -> "DELIVERED" else "CREATED" | ||
| salesOrderSystemStatus | payload.SalesOrderBulkReplication.SalesOrder.OverallTotalDeliveryStatus | "" | |
| orderStartDate | payload.SalesOrderBulkReplication.SalesOrder.SalesOrderDate | "" | |
| developerStatusCode | payload.SalesOrderBulkReplication.SalesOrder.OverallSDProcessStatus | "" | |
| externalIds.externalIdType | "SAP_4HANA" | Hardcoded as SAP_4HANA | |
| externalIds.externalId | payload.SalesOrderBulkReplication.SalesOrder.SalesOrderID | "" | |
| externalIds.id | "" | set to "" | |
| externalIds.statusLastChangedDate | NA | "" | |
| externalIds.status | NA | set to "VALID" | |
| salesOrderType | NA | NA | set to "INITIAL" |
map-organization-to-cim
SAP HANA Platform Event Business Partner message to CIM Mapping
Source:
./src/main/resources/dwl/map-organization-to-cim.dwl
Functions
fun getFormattedDateTime (toFormat)
Formats the date-time to the type accepted by CIM
Mapping Tables
Maps event payload from SAP HANA Business Partner Event Listener to CIM Customer format.
| CIM - Customer | Event payload from SAP HANA Business Partner Event Listener | Description |
|---|---|---|
| id | businessPartner.Common.YY1_SME_MPARTYROLEID_M_bus | The Global ID of the customer in MDM system |
| partyRoleType | "Customer" | The party role type - Set as "Customer" |
| party[0].id | businessPartner.InternalID | The party identifier - Set as null |
| party[0].partyType | "Organization" | The party type - Set as Organization |
| party[0].name | Name.FirstLineName | The Name of the Organization in SAP HANA |
| party[0].legalName | Name.FirstLineName | The Legal of the Organization in SAP HANA |
| party[0].contactPoints[0].contactPointType | "ContactPointAddress" | The contact point type - Set as "ContactPointAddress" |
| party[0].contactPoints[0].id | null | The contact point type identifier in SAP HANA - Set as null |
| party[0].contactPoints[0].activeFromDate | address.ValidityPeriod.StartDate | The date from which the contact point is active - Set as Start date |
| party[0].contactPoints[0].addressLine1 | address.Address.PostalAddress.StreetName | The Mailing street of the customer in SAP HANA |
| party[0].contactPoints[0].cityName | address.Address.PostalAddress.CityName | The Mailing City of the customer in SAP HANA |
| party[0].contactPoints[0].postalCodeText | address.Address.PostalAddress.StreetPostalCode | The postal code of the customer in SAP HANA |
| party[0].contactPoints[0].stateProvinceName | address.Address.PostalAddress.RegionCode | The state province of the customer in SAP HANA |
| party[0].contactPoints[0].countryName | address.Address.PostalAddress.CountryCode | The country of the customer in SAP HANA |
| primaryFlag | "true" | Set as true |
| isUsedForBilling | "false" | Set as false |
| contactPoints.geoLatitude | NA | Set as null |
| contactPoints.geoLongitude | NA | Set as null |
| contactPoints.geoAccuracy | NA | Set as null |
| party[0].contactPoints[1].contactPointType | "ContactPointEmail" | The contact point type - Set as "ContactPointEmail" |
| party[0].contactPoints[1].id | null | The contact point type identifier in SAP HANA - Set as null |
| party[0].contactPoints[1].activeFromDate | address.Address.Email.ValidityPeriod.StartDate | The date from which the contact point is active - Set as Start date |
| party[0].contactPoints[1].emailAddress | address.Address.Email.URI | The Email address of the customer in SAP HANA |
| primaryFlag | "true" | Set as true |
| party[0].contactPoints[2].contactPointType | "ContactPointPhone" | The contact point type - Set as "ContactPointPhone" |
| party[0].contactPoints[2].id | null | The contact point type identifier in SAP HANA - Set as null |
| party[0].contactPoints[2].activeFromDate | address.Address.Telephone.ValidityPeriod.StartDate | The date from which the contact point is active - Set as Start date |
| party[0].contactPoints[2].telephoneNumber | address.Address.Telephone.Number.SubscriberID | The telephone number of the customer in SAP HANA |
| primaryFlag | "true" | Set as true |
| isSMSCapable | "false" | Set as false |
| externalIds[0].id | null | The identifier for the externalId entry - Set as null |
| externalIds[0].externalId | Id | The identifier of the customer in SAP HANA |
| externalIds[0].externalIdType | "SAP_4HANA" | The external identifier type - Set as "SAP_4HANA" |
| externalIds[0].status | "VALID" | The status of the ExternalId - Set as "VALID" |
| customerNumber | businessPartner.InternalID | The customer number stored in SAP HANA - default as "" |
| customerStatus | "ACTIVE" | The customer Status in SAP HANA - Set as Active |
| auditInfo.createdDate | now() | Timestamp of when the customer was created |
| auditInfo.createdBy | CreatedById | Identifies the system or user which created the customer |
| auditInfo.updatedDate | now() | Timestamp of when the customer was last updated |
| auditInfoupdatedBy | LastModifiedById__c | Identifies the system or user which last updated the customer |
| auditInfo.isDeleted | IsDeleted | Indicates whether or not the customer has been soft-deleted |
| salesOrganization | customer.SalesArrangement.SalesOrganisationID | The Organization Id in SAP HANA |
| distributionChannel | customer.SalesArrangement.DistributionChannelCode | The DistributionChannelCode Id in SAP HANA |
| division | customer.SalesArrangement.DivisionCode | The DivisionCode Id in SAP HANA |
| customerPricingProcedure | customer.SalesArrangement.PricingProcedureDeterminationCodeLong | The PricingProcedureDeterminationCodeLong Id in SAP HANA |
| customerRole | businessPartner.Role.RoleCode | The RoleCode Id in SAP HANA |
| primaryAccount | YY1_SME_ParentID_MFG | The Primary Account ID |